CREATE TABLE [dbo].[TransactionRoleAccounts]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[TransactionRoleId] [int] NULL,
[AccountId] [int] NULL,
[Status] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TransactionRoleAccounts] ADD CONSTRAINT [PK_RoleAccount] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TransactionRoleAccounts] ADD CONSTRAINT [FK_RoleAccount_Account] FOREIGN KEY ([AccountId]) REFERENCES [dbo].[Accounts] ([Id])
GO
ALTER TABLE [dbo].[TransactionRoleAccounts] ADD CONSTRAINT [FK_RoleAccount_Role] FOREIGN KEY ([TransactionRoleId]) REFERENCES [dbo].[TransactionRoles] ([Id])
GO
